Tabela WMPCODING

Definicja tabeli WMPCODING

Name

WMPCODING

Code

WMPCODING

Comment

Kodowania WMP


Lista kolumn tabeli WMPCODING

Name

Code

WMPCODINGID

WMPCODINGID

COMMENTARY

COMMENTARY

WMPCONTRACTID

WMPCONTRACTID

EPISODEID

EPISODEID

ICD10CODE

ICD10CODE

ICDID

ICDID

SENDINGTOVERIFICATIONPERSONID

SENDINGTOVERIFICATIONPERSONID

STATUSID

STATUSID

WMPTREATMENTMETHODID

WMPTREATMENTMETHODID

VERIFICATIONFIRSTCOMMENTARY

VERIFICATIONFIRSTCOMMENTARY

VERIFICATIONFIRSTDATE

VERIFICATIONFIRSTDATE

VERIFICATIONFIRSTPERSONID

VERIFICATIONFIRSTPERSONID

VERIFICATIONSECONDCOMMENTARY

VERIFICATIONSECONDCOMMENTARY

VERIFICATIONSECONDDATE

VERIFICATIONSECONDDATE

VERIFICATIONSECONDPERSONID

VERIFICATIONSECONDPERSONID


Kolumna WMPCODINGID tabeli WMPCODING

Definicja kolumny WMPCODINGID tabeli WMPCODING

Name

WMPCODINGID

Code

WMPCODINGID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator kodowania WMP


Kolumna COMMENTARY tabeli WMPCODING

Definicja kolumny COMMENTARY tabeli WMPCODING

Name

COMMENTARY

Code

COMMENTARY

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz


Kolumna WMPCONTRACTID tabeli WMPCODING

Definicja kolumny WMPCONTRACTID tabeli WMPCODING

Name

WMPCONTRACTID

Code

WMPCONTRACTID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator kontraktu


Kolumna EPISODEID tabeli WMPCODING

Definicja kolumny EPISODEID tabeli WMPCODING

Name

EPISODEID

Code

EPISODEID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator epizodu


Kolumna ICD10CODE tabeli WMPCODING

Definicja kolumny ICD10CODE tabeli WMPCODING

Name

ICD10CODE

Code

ICD10CODE

Data Type

VARCHAR2(255)

Mandatory

No

Comment

kod ICD10


Kolumna ICDID tabeli WMPCODING

Definicja kolumny ICDID tabeli WMPCODING

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator kodu ICD10


Kolumna SENDINGTOVERIFICATIONPERSONID tabeli WMPCODING

Definicja kolumny SENDINGTOVERIFICATIONPERSONID tabeli WMPCODING

Name

SENDINGTOVERIFICATIONPERSONID

Code

SENDINGTOVERIFICATIONPERSONID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator osoby wysylajacej kodowanie do weryfikacji


Kolumna STATUSID tabeli WMPCODING

Definicja kolumny STATUSID tabeli WMPCODING

Name

STATUSID

Code

STATUSID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator statusu kodowania


Kolumna WMPTREATMENTMETHODID tabeli WMPCODING

Definicja kolumny WMPTREATMENTMETHODID tabeli WMPCODING

Name

WMPTREATMENTMETHODID

Code

WMPTREATMENTMETHODID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator metody leczenia


Kolumna VERIFICATIONFIRSTCOMMENTARY tabeli WMPCODING

Definicja kolumny VERIFICATIONFIRSTCOMMENTARY tabeli WMPCODING

Name

VERIFICATIONFIRSTCOMMENTARY

Code

VERIFICATIONFIRSTCOMMENTARY

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz pierwszej osoby weryfikujacej


Kolumna VERIFICATIONFIRSTDATE tabeli WMPCODING

Definicja kolumny VERIFICATIONFIRSTDATE tabeli WMPCODING

Name

VERIFICATIONFIRSTDATE

Code

VERIFICATIONFIRSTDATE

Data Type

DATE

Mandatory

No

Comment

data pierwszej werfikacji


Kolumna VERIFICATIONFIRSTPERSONID tabeli WMPCODING

Definicja kolumny VERIFICATIONFIRSTPERSONID tabeli WMPCODING

Name

VERIFICATIONFIRSTPERSONID

Code

VERIFICATIONFIRSTPERSONID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator osoby dokonujacej pierwszej weryfikacji


Kolumna VERIFICATIONSECONDCOMMENTARY tabeli WMPCODING

Definicja kolumny VERIFICATIONSECONDCOMMENTARY tabeli WMPCODING

Name

VERIFICATIONSECONDCOMMENTARY

Code

VERIFICATIONSECONDCOMMENTARY

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz drugiej osoby weryfikujacej


Kolumna VERIFICATIONSECONDDATE tabeli WMPCODING

Definicja kolumny VERIFICATIONSECONDDATE tabeli WMPCODING

Name

VERIFICATIONSECONDDATE

Code

VERIFICATIONSECONDDATE

Data Type

DATE

Mandatory

No

Comment

data drugiej weryfikacji


Kolumna VERIFICATIONSECONDPERSONID tabeli WMPCODING

Definicja kolumny VERIFICATIONSECONDPERSONID tabeli WMPCODING

Name

VERIFICATIONSECONDPERSONID

Code

VERIFICATIONSECONDPERSONID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator drugiej osoby weryfikujacej


Lista kluczy tabeli WMPCODING

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WMPCODING

Definicja klucza Identifier_1 tabeli WMPCODING

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment